SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544893 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544893 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798345,372146,880867,272844,124440,243795,191750,900853,116008,877123,308488,712111,727247,80793,1045536,322752,309055,1022470,104911,338141,607459,417687,944669,797148,226525,982687,608840,818019,16104,1040501,283026,120134,736853,382399,460298,764169,746463,449956,429938,653022,490572,108758,1036844,850281,547892,720555,804855,369672,79260,223308,769991,847158,649860,360573,1015684,930457,174260,804835,107260,118389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]