SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520833 LIMIT 1 [ RunTime:0.002701s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520833 [ RunTime:0.002519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528816,650449,27245,731537,181315,886005,637185,447904,371760,442485,432371,1036099,924983,826127,255507,550529,160850,590039,145832,556736,692906,957010,30319,852539,972363,751230,899105,298345,884982,1041,702966,650002,633030,1001711,572153,415150,473465,405903,289173,722322,474223,681892,60709,658277,693472,67276,465318,499162,648169,273114,43263,894286,871462,656704,941735,710338,712982,213652,703148,220295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]