SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290521 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290521 [ RunTime:0.002566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722910,563713,246941,172561,392376,148997,98716,705733,268082,286204,14285,385406,807389,347654,405704,225807,332586,673565,5783,804300,300887,832007,226206,20903,986412,121285,145622,381964,725875,871031,660369,1019218,539592,456247,180042,471453,395006,479710,1009504,535189,592442,805530,608260,154724,986216,263913,823610,924103,889197,614648,505035,217905,831445,504926,155888,498215,954631,795055,787054,239504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]