SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554800 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554800 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696490,1006888,87754,997679,186227,246196,64907,945614,895976,487568,642204,141427,413517,847366,947176,199143,356109,64118,430390,986820,270440,307780,286547,266253,178066,816290,790811,727128,499496,901506,145765,149796,155236,321573,192010,267748,560332,432746,939553,94950,475556,232524,200431,462998,450443,411062,99883,129176,130500,63259,383489,966608,470677,756231,785430,1039038,725280,701279,962341,391011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]