SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006911s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467303 LIMIT 1 [ RunTime:0.003982s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467303 [ RunTime:0.008015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999173,551686,173892,114416,85124,955237,237970,260105,68875,887825,448585,732738,358115,472161,97629,154281,241673,132540,373790,384578,748333,321496,683980,637372,588585,457713,754589,713348,901957,504317,828370,907571,237522,954111,475022,200592,493791,510868,755843,1023320,101689,124716,444364,172534,361763,343658,733258,185056,335844,419876,100824,269686,175576,272917,1037638,310493,738364,543089,622841,536513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007073s ]