SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804200 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804200 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623641,1003393,171694,350793,1019221,519470,1713,34513,644874,748853,39633,108464,261252,866740,757720,251621,711659,1036858,746299,280224,173717,542960,884961,1030234,560313,613964,228609,971862,989393,92254,891162,774608,170056,328743,114432,445955,392354,86324,119442,191599,670559,845826,568574,552629,908187,186822,744054,207345,144352,831710,98279,531673,946099,359266,656163,432380,815146,828999,737466,583622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]