SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430104 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430104 [ RunTime:0.003386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941248,650825,169621,321247,784200,553348,617315,1028439,614526,946503,383387,801314,871610,881485,481776,475845,259438,804302,574793,974499,428734,65953,358249,951727,69812,176697,125360,453526,376853,767671,140095,506497,832628,38500,16141,440188,536784,891412,561732,292339,661207,194231,104855,237133,648770,86742,176696,426631,400868,341601,167208,325461,801881,49689,700510,447305,968258,629748,469214,828637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]