SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486713 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486713 [ RunTime:0.003136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78698,986011,118696,620719,334649,248764,49274,919536,559381,986652,735905,780400,813831,94543,48521,378886,417385,419171,822219,968842,341159,252300,671852,403627,109742,722180,1012966,786845,33560,879831,980223,951895,702637,844898,221694,358537,193732,552501,193900,425864,871437,605109,1024607,994957,1017679,497228,318127,411656,791724,71398,723397,287671,400644,809910,809960,811300,803790,423144,207405,439897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]