SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106269 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106269 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938543,188672,238925,443234,943017,465267,943997,211026,757970,850597,1005347,389314,629142,1021509,620176,145138,899541,60132,420702,741202,461421,32785,783899,932315,204263,419774,99806,247911,298373,374479,256040,968013,198378,166882,685061,407815,786699,396708,780263,715638,30398,429260,187282,126835,885642,693180,124512,108008,40300,763526,362133,970308,32036,494880,996837,799668,476313,95427,172060,634121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]