SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405708 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405708 [ RunTime:0.002755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430543,568598,37131,395664,285618,358077,583496,425304,318806,26408,525804,315870,895542,917669,447426,571411,425129,936946,115465,227023,324624,541717,400072,66813,576402,134925,963254,553734,821092,279300,163949,65355,335823,427298,487870,45208,101415,1048129,994264,304485,102995,664244,93647,38665,48072,209478,15355,894061,606767,310502,460251,2567,465205,382514,808671,617679,517706,362972,529435,693329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]