SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014311 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014311 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940595,783821,682214,916104,936758,874417,660963,791062,31,350475,900889,807667,379412,86265,229281,44675,1019598,221375,573045,369419,833288,562960,567626,309743,929120,581065,387051,616453,181952,1044325,748359,1012807,856926,592708,202483,112603,524434,836964,471587,67815,914949,580301,11548,710809,474662,214503,775658,1022904,892715,213285,315948,686584,670060,197816,515669,564303,998217,1025751,695518,513537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001672s ]