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` = 634012 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 634012 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518015,971923,851313,342249,277033,1015877,921522,813010,482819,591806,471994,417254,749061,489140,885576,364687,443976,866324,746132,338264,899395,959185,718236,98899,463142,208810,309328,866835,115469,52703,903452,1021082,212099,1026132,89686,16669,554533,64917,1033014,484118,574512,91497,165776,661729,471470,633500,577454,723552,422544,455567,797242,854245,228744,131884,95075,991029,468117,989398,497150,688212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 634012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 634012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]