SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 74191 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 74191 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710675,760102,559139,1028921,903440,556558,392745,114535,775654,1008101,360961,649160,520781,190725,82406,748772,310356,922783,333234,877845,85687,128825,700301,481992,998793,760078,481542,962995,983760,364570,351153,222216,294588,606392,691252,443646,722980,590637,260201,912439,327686,967411,251574,571304,196095,433267,873280,234900,985148,255088,22653,974918,423662,933067,962840,366482,17498,656964,406063,1002422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 74191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 74191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001820s ]