SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545335 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545335 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388713,154701,499170,713806,71535,837116,498546,305731,691352,86956,605244,218905,147912,352550,64130,1003553,747448,572955,608149,28963,663129,342820,884754,382774,248809,275344,728503,772640,297790,648367,488211,39923,619313,271561,985060,794840,285943,169025,177154,946267,681135,110423,687278,986669,800134,657552,195522,150767,483366,1048041,404229,441626,845477,691156,30239,584979,509621,804745,55031,728882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001813s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]