SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412253 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412253 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871054,382768,987353,522896,102698,386655,763305,846069,377524,173986,65100,399146,634814,448141,101693,140087,977427,520709,908736,419281,604118,748218,130886,746805,492953,99767,337525,620251,415158,966166,757157,652784,713821,24695,854796,229993,292807,39947,666600,99056,906392,311889,14073,194613,408683,4903,912840,790424,748101,250463,43578,366421,80451,612416,871545,1043172,485063,518681,139316,81471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]