SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710623 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710623 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799438,37001,1012121,1015599,961204,937372,333700,253856,425387,332728,325997,235236,445814,476960,374370,361788,1013420,328917,782410,253801,8140,691932,7778,1044482,274764,955395,846212,1047905,664248,901860,633882,190469,704181,635699,208764,649623,295972,594072,323076,670661,165152,723914,12006,226601,20346,390066,890080,343186,521544,615174,75332,905185,765761,438768,427543,807961,876776,722739,310603,760527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]