SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326445 LIMIT 1 [ RunTime:0.003114s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326445 [ RunTime:0.004027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466071,390072,1026292,375988,272044,112678,801655,328976,174274,555947,227100,108866,937055,317061,64896,292228,126568,267931,543868,786307,968862,13644,708247,358413,937132,64930,940440,387443,694696,26746,805289,661872,983639,348022,802313,505081,397926,478259,24416,959149,527669,351675,706898,933017,762468,626663,835799,1048025,696678,520270,220968,421666,978439,161675,727675,699469,122362,53198,158949,718056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]