SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505474 LIMIT 1 [ RunTime:0.001236s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505474 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918550,758782,852281,721769,44083,59948,499054,1019606,34489,1024836,528891,299579,643767,22397,766847,448239,112269,667514,41321,873313,66060,444883,53439,608852,528900,600222,920836,419927,792887,82114,745010,436372,546164,1023475,531149,979430,195912,273919,1022131,228638,994248,472980,800514,975262,479130,337358,112841,411674,790535,239984,1010470,617708,361761,166819,494368,851244,29366,776149,126215,72564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]