SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509985 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509985 [ RunTime:0.002379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004123,696985,955865,945972,435986,369669,913064,354230,887554,995942,359732,750274,1004982,279147,583465,660801,348705,9811,748659,471499,661163,322727,1046603,697980,583497,1042978,280206,912110,352634,610468,963873,511772,822442,751258,1025938,974063,555986,632762,443605,512716,752421,949164,850860,622317,392821,262348,913187,968652,866266,43730,561821,415019,606383,846290,319382,15603,398384,663180,957507,849938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]