SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468071 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468071 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878103,1024519,440011,441126,779067,771491,1022205,29240,769550,890441,899972,956597,740586,49453,226467,374242,233577,589322,878766,140553,916681,594269,687624,812687,997112,714758,334348,440416,653386,641578,89422,444649,322413,370362,1036930,192054,281821,512941,525491,335537,197072,990604,686762,963457,757488,62278,49962,807058,394328,855009,472085,918653,36872,507893,702651,35263,418007,431888,320143,849636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]