SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281194 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281194 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435486,841848,425880,828470,719154,195650,486669,1030827,929895,2752,591589,1044952,401287,685710,995608,66455,818631,367408,484574,801654,634846,313979,936431,605188,169396,364353,591563,408742,703991,522989,441542,900317,987034,1044731,48030,796742,136458,741968,1023869,512967,953831,534444,1008149,485675,684310,967979,424401,632842,581106,669410,962708,543623,36822,98063,118689,796026,279879,233530,6426,174711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]