SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301448 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301448 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140192,675707,378233,355804,77579,113678,332148,493856,458401,431599,290691,246448,11642,742667,963871,681882,906095,697489,478684,692052,694622,237842,461748,559003,174679,902566,862237,283023,972880,96592,32630,400147,583192,921470,580981,462768,9198,1042761,873675,857388,416071,184350,126100,396785,618911,810861,596590,946643,939827,462034,415145,686131,555362,720321,379209,1042494,228909,240860,1043597,791931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]