SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483810 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483810 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295367,824410,33250,432667,82006,137795,897915,1037122,979550,310370,268860,586372,817932,951164,851217,567933,23951,390459,320484,714477,411210,984311,541025,249471,241495,885430,113024,142823,662937,534869,656454,559952,632261,958818,883455,679210,268764,210061,157334,573494,829212,558380,899185,570901,940475,243754,300822,792616,403722,597121,193724,40603,365559,46763,195144,524752,455932,802687,951721,5956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]