SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300020 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300020 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308974,456925,338489,502542,27277,694474,1043407,600215,562924,629857,766238,555444,245468,930400,828859,900664,467360,734924,377988,794803,25923,505258,618894,705106,988071,684015,468411,122956,307226,595330,781572,252589,167190,161218,776312,265879,843769,497913,798083,451657,985528,397518,49552,137264,744029,158882,632709,943025,89559,259891,467912,642369,623666,343233,169040,421156,845596,880709,875006,141566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]