SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440628 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440628 [ RunTime:0.002769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023616,400858,544558,512099,12524,572865,710507,344608,85119,1031913,10381,902631,57694,86499,451629,201577,406594,784198,685602,231940,202577,826804,907622,340463,379426,388606,1012904,201751,575716,203227,568373,49905,180842,814839,89400,43682,536836,163586,23688,730068,130239,768813,926615,304860,968698,204771,882242,486942,693939,660077,322091,662610,353876,412107,811718,280156,272701,406319,657529,824256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000789s ]