SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394053 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394053 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959212,197166,555615,370987,76308,1000110,70919,578057,827606,191404,717771,489300,15557,670040,93440,277128,1040550,770977,802646,219074,758297,821059,73746,747611,326741,44324,412087,540033,433070,240810,728780,228280,727096,680561,622105,1038444,140983,689187,567634,897988,325838,470272,755881,88861,940013,393365,903335,667778,602187,942854,135079,19232,194789,956600,3343,887639,409744,684549,1034300,317632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]