SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 793654 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 793654 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039583,341570,662681,817515,922646,514924,1004507,608637,261208,973882,122540,783316,43432,111278,264595,415646,1024475,752527,407610,414347,63116,320283,120174,724718,475087,34386,171251,718449,1021749,669738,1027373,740570,113532,352189,686822,863236,398848,295296,158021,68635,312664,379918,436628,32452,163940,869075,315652,286394,359090,840016,148628,178375,993600,138374,912256,710710,831317,102981,1022850,528414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 793654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 793654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]