SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505600 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505600 [ RunTime:0.001359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842829,575983,171231,753519,1023471,99145,747798,351346,502759,410649,426151,449787,209042,766419,450680,764916,865597,636007,1040505,606474,97186,578645,544825,675561,427011,608924,677018,727322,763989,77154,279412,868207,805364,387073,234691,63421,651086,559289,175706,747566,479558,491589,435309,440809,339869,812022,528761,688625,918811,493126,355303,277585,392824,399398,826644,490052,416998,664628,471517,203317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]