SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403857 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403857 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140222,323514,565123,814777,1042789,512251,439449,390717,771759,333155,419821,216920,16161,98580,239537,136600,307523,22811,58240,86074,819925,492200,664153,158565,378638,122364,883669,749328,180831,168692,820549,1045360,666877,279930,627321,15075,619091,846349,142042,554241,27102,255428,982782,547222,515313,847465,705238,69184,933244,33152,870965,716154,564116,722261,785448,850335,15959,934413,316467,723295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]