SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500910 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500910 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104317,903464,859137,651547,979782,949370,84934,245778,391255,25270,703053,839719,522876,634975,989336,1045208,398983,704750,397850,1030797,484409,37142,86516,755512,77700,110064,914409,440912,347403,105116,345185,622245,781901,1029245,881670,29227,850469,1023478,789497,492730,772800,747209,223454,281500,362090,341619,302315,431673,518927,65565,253574,576952,534297,254448,1024565,849567,102545,955487,982792,34723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]