SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542963 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542963 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956534,387207,948830,831638,46570,623000,913554,264156,1012227,566980,479889,10503,729721,707382,86721,11785,574561,1037959,246041,302652,826453,637498,21703,275224,488292,500746,742914,654066,466897,712919,349259,317666,781334,287596,274377,1016277,997580,669316,765445,396534,113375,21955,116953,875946,382416,518154,327716,1036601,857900,865638,197697,242162,808858,200379,540183,522894,1012941,397903,32621,834374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]