SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036 LIMIT 1 [ RunTime:0.000671s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77175,742273,444418,65198,255671,747943,782200,640462,805865,784015,702787,166904,981241,908755,842956,979238,28941,581685,970934,888297,866002,542259,77719,766489,115655,168624,521657,376195,297645,1009846,102151,383910,919764,665574,501899,403338,899535,427200,634880,102783,219153,104331,691149,523030,379098,641306,596691,107675,727188,20171,82547,690543,1048211,529294,2593,348894,149002,374597,614956,498469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]