SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410151 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410151 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319076,288676,135227,349831,363815,776756,894642,639798,2574,801768,139636,478594,226169,327435,398424,530925,999591,961101,397883,481746,712765,1038036,482838,172108,743016,908416,205580,293781,105038,523206,5054,658163,1020022,263087,20914,395904,597820,302998,661678,1030813,218933,826717,836105,547722,428907,954189,915789,1026498,959729,225511,486425,22360,905211,141502,362450,206779,778545,653317,1028047,29525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]