SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481201 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481201 [ RunTime:0.002979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869228,723636,360108,11534,921676,968457,472244,780489,657082,263809,505441,373067,430938,42103,42374,285300,428830,443029,634030,404303,302369,28829,667808,206766,268170,914242,519341,231312,673232,476139,627474,497630,559271,417496,595199,698806,808223,877780,1032988,204662,237573,904950,351542,760992,847981,262939,161689,354515,166985,588562,82543,1017205,820871,546965,551178,303282,559535,193748,558341,819583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]