SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107085 LIMIT 1 [ RunTime:0.003083s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107085 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72655,185488,371512,415806,130302,771688,1002617,19748,1002523,661613,178142,668273,913934,952751,279803,509441,867187,117389,681776,622388,597510,643735,842148,72987,756916,129512,392012,649163,709889,744826,400298,120010,227554,754894,444055,446985,649261,455459,346173,680127,457886,809224,1047336,80198,661929,1020366,723809,234678,349527,1027365,328606,762229,460930,717888,720831,576508,524222,452369,648290,526055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]