SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285934 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285934 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264541,259934,102840,999045,601368,738376,312902,633833,898476,600476,181359,848759,1036609,986289,594436,708346,847475,268294,1017146,710205,38386,656236,867892,815905,969507,764410,366632,425891,227172,41569,661674,211138,245740,37406,269014,173787,135834,312281,90255,1010031,664144,464291,226747,653353,9566,829399,232342,178042,383038,245081,774878,323771,151493,528854,689116,249433,366791,4430,755807,625392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]