SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291329 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291329 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016052,397497,236704,250680,771076,356840,1047588,797291,903846,662180,754709,722357,921198,669449,254972,752297,1028956,843643,70200,789473,136658,347301,185400,107433,919645,299307,501534,816077,40842,192556,625481,770364,798623,1011335,411064,258838,759852,745901,466341,591313,383034,551223,766910,893580,650338,1022809,922120,622201,182797,254685,899657,437012,190619,593320,178875,637128,12090,351150,263989,584069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]