SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302008 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302008 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689041,901531,626654,346518,113065,21123,540104,369096,180373,93,375962,151516,612965,675090,363595,93483,806324,984744,541949,352665,841475,87441,137705,978707,705305,513047,98623,244248,896234,923558,890746,80273,969250,679517,830426,247372,187526,548941,775348,474572,597811,290170,430297,230096,864760,175886,1038658,644473,732883,339701,717377,921026,117571,406116,739387,519537,222835,971655,606147,4351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]