SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411000 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411000 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813904,846021,895898,759125,287383,447033,710148,1046026,873236,491448,581446,518752,541512,181850,906285,159430,484866,621982,798190,745360,588689,598119,804975,764979,232257,1857,96372,201670,1012811,464204,343456,441540,443369,267674,996418,803849,147740,231951,76907,140700,681177,110410,225630,653258,425073,992903,604967,809507,353630,44259,1017201,258532,374649,1018153,593526,518287,321470,94255,611986,902849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]