SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501998 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501998 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234714,727145,642777,536454,194433,101115,976266,820914,349218,32224,828156,65386,1028282,307593,476790,35724,1026348,408373,255207,337245,925973,305382,244422,232475,589293,584185,84051,102969,897323,561953,181988,719731,1007080,492431,444724,274765,769626,478964,680772,515179,201758,332266,441758,592610,999055,510964,615037,304821,466977,156797,929871,370303,944422,109301,388297,338847,73368,982125,817143,321070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]