SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003772s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485378 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485378 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882628,607302,403511,352179,805585,827769,677938,470492,410882,1008337,761763,741436,1002550,1015588,130799,39194,982055,85664,323302,633725,106992,224867,713069,765207,630412,221278,940971,1011025,863125,445472,128083,829566,1005571,527575,61480,169818,417353,406617,825146,640423,781146,639912,335993,452532,374994,9434,823523,698007,553373,191028,613254,467015,448380,427903,820311,291357,664572,333509,64695,458962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]