SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009255 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009255 [ RunTime:0.005104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116898,308811,870419,340361,198784,516613,192731,290822,363145,225786,1017156,1026159,226890,17306,420915,798280,492580,835405,187396,99736,1032506,47024,240981,900796,986779,58066,317901,464158,685696,931373,906630,652276,396801,905222,275756,845066,605679,990244,470951,45472,977307,77979,1007548,273013,159620,244230,654825,731317,663434,133222,641867,828964,387616,350524,570652,847937,608220,851791,527794,9838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009255 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009255 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]