SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589846 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589846 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441374,512397,987547,620661,370285,482599,22357,459056,583963,370236,708662,851880,968343,918288,860365,63607,230191,48582,30154,1007144,437688,331689,369853,859123,1033509,762161,569195,825967,331026,381379,887129,600513,994500,234102,692653,550183,302679,116983,373529,779032,195128,589763,29257,811829,71842,598396,593230,850545,137446,747214,155186,624248,720641,645692,806122,849044,228547,2635,65210,495516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]