SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569291 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569291 [ RunTime:0.003037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132182,1030605,985273,762781,260651,819338,141628,870910,755924,616477,520974,31408,279053,919572,912408,709471,925709,390202,1047204,192405,290530,113210,924899,873361,632678,114118,291657,554513,1000850,208110,338760,814052,499317,771363,174256,534959,952594,65444,718052,633198,487435,677750,76345,750670,473329,639295,546700,1048855,646053,845712,936268,717560,759059,727160,313704,59961,870399,159399,902567,9833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001583s ]