SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511818 LIMIT 1 [ RunTime:0.000802s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511818 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886520,876245,822498,344724,1012942,113242,908332,230832,534655,426310,593614,962560,450227,363817,986138,64559,307572,1018584,3215,235397,885905,489671,1023229,808629,795098,388576,577187,298953,75339,381131,825946,601123,405649,275468,506285,198186,1011121,352802,487884,420478,339952,11462,82732,466923,1007141,352938,1043852,425259,993880,1000374,691088,594091,13114,338398,347180,785110,899629,93918,817540,692648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]