SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421017 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421017 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787039,955524,932224,84673,813281,197680,104622,502493,436865,1001340,965426,405357,672321,323260,103479,800608,258742,287425,329304,43492,182614,1007543,673490,614252,71114,6968,549237,1017446,296185,648118,671856,315203,299103,176274,608197,904076,239553,112722,112660,568773,766010,926021,833516,1018841,486817,259148,45621,97681,985386,296408,360704,386836,537543,245819,881517,319555,332857,529635,538686,753067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001434s ]