SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 137911 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 137911 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420014,839439,715178,451291,118368,462032,283274,832113,843883,593329,246972,656081,696797,181202,966797,51188,941633,919272,867263,804451,36178,764989,519837,490841,14023,59753,1045991,162979,944551,81863,732576,732733,573184,62898,324571,632750,527438,204350,899757,725865,240376,1003087,1021204,955742,836500,980799,740296,53543,956662,674432,14318,272553,829552,303389,565839,365315,130583,348076,985987,259994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 137911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 137911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]