SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449776 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449776 [ RunTime:0.003630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620182,778761,148026,531613,345814,348118,8888,642149,514125,441404,328483,1012411,151907,268261,533493,798711,776636,660903,690480,268748,827390,625980,432355,505236,798597,464713,27601,919836,115176,424568,536070,971946,500726,699548,804417,108751,451990,620650,664203,806288,847187,873188,54556,427413,984513,712118,971518,889354,761132,251695,903964,626501,335481,405968,457261,809450,753598,578979,604841,572742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]