SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505063 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505063 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646533,405057,808554,462305,905476,1037548,173102,578100,692959,938908,730430,506614,237389,970423,263535,129896,956579,1015473,968535,331225,482349,390424,893130,882905,522250,255390,50416,941846,661043,949630,527950,58495,794825,90583,885194,26130,254667,503716,461503,757347,848868,422077,218599,1034941,344746,817076,52658,715907,454429,440206,93654,215652,737237,176558,788039,914944,88398,931746,577867,327465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]