SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104550 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104550 [ RunTime:0.003069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511775,391210,821941,788198,364664,267732,414229,413959,1035554,789828,496229,443364,812924,345808,460609,73551,925747,650072,507481,571869,371223,790681,828353,164584,341596,456247,156847,555408,870330,171217,290663,631530,198717,831825,400466,97088,782943,374211,404130,11666,431036,676168,405392,238876,352107,61260,697567,956287,293767,92088,647500,942255,631449,756269,943414,715378,813580,695148,644516,560510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001717s ]