SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449518 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449518 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546200,862487,494063,539849,928788,361822,125697,201485,617552,644296,866119,665297,747134,347005,21819,501974,843973,794470,108026,802171,424474,248622,40930,681177,653536,424039,1042842,144045,662208,153706,158478,728034,550223,211755,109441,832233,614716,1017775,829542,78063,846873,583337,728232,173229,755437,605579,764122,1014220,425548,915314,880321,64036,710714,660779,480417,119608,902154,924628,300116,258238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001084s ]