SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503847 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503847 [ RunTime:0.003410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422374,670310,277884,228793,550669,268231,430904,929905,418221,541286,10202,1014310,377882,278055,804970,637978,250747,742656,122556,429617,559701,21792,827022,161093,50922,952344,891963,413001,237910,860434,751350,510727,267285,403250,859749,468721,265624,582460,467478,451684,515523,578044,93503,74228,650620,400608,89799,164106,251678,5475,80688,472183,1036977,195503,570648,441652,422213,387541,202888,347374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]