SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526210 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526210 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115439,1016611,1045337,865022,741258,486131,691162,763183,222278,55910,41278,435443,294617,489009,1040741,167426,281703,782473,875667,561019,484041,136207,713801,500345,281659,953371,819595,870969,814023,143542,485825,214535,4059,45011,899180,435931,312019,69034,962011,64681,814115,128527,273262,1021963,632949,552465,836610,272898,848293,312766,249079,382334,571552,454613,494788,175124,107952,620604,622476,301591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]