SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190497 LIMIT 1 [ RunTime:0.000740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190497 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674158,961753,231339,81018,354871,142243,288528,996243,794667,769702,762201,363525,605597,845456,363275,147062,883834,393683,990938,824631,674530,855935,415800,423922,199547,599971,795388,848630,999053,964860,1041931,411354,1040038,312386,666759,171575,412287,134876,947582,871254,1040598,338363,256356,823772,1014425,648261,526047,347578,288181,220481,493351,225291,569750,22844,1011591,329323,819628,225301,643464,134520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002424s ]