SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301528 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301528 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264042,372266,665472,727490,926948,317780,120202,774861,828577,287980,579876,320289,356023,334855,146056,145774,275736,588652,514463,485041,757594,814016,149812,723777,942044,257588,472818,26728,425610,448628,852350,568017,158228,320933,211450,365886,383624,950773,300391,703697,688685,713227,1019649,296114,567229,916772,838887,794027,939770,262708,57362,775622,1012014,531141,591723,258257,430043,166621,200436,602645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]