SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485713 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485713 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16175,836990,331373,268332,565549,264064,207423,523955,740165,546677,257982,180528,168853,696919,1041183,478812,285982,863314,849280,445979,257659,664186,360906,539022,167152,316322,90782,299350,847403,423755,561982,397735,614164,398309,510518,299276,357155,652694,1044476,684166,933774,104410,1020788,208741,1045851,699170,238771,544776,620821,726692,488987,537021,834860,336597,475470,648063,976627,37099,460996,330264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]