SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341038 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341038 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535234,166653,722155,217644,892294,272830,737086,543637,85093,808388,700194,914850,976426,83013,1048451,687833,350928,573187,625625,287100,753303,480280,546240,61522,888463,554904,3188,976480,915035,58259,369241,490601,1031682,311589,218438,331108,672557,141242,123642,179697,95343,62250,166618,274605,458324,67421,436947,531882,428384,317472,411235,274493,512425,643582,599895,834605,177009,966117,831403,487551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000794s ]