SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526453 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526453 [ RunTime:0.003449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619863,524336,350055,770215,862762,907504,662407,316322,230544,1034584,538587,115920,194991,372948,695232,267137,578418,312436,178747,454614,231772,812919,999661,1043447,856305,1005572,182249,283024,125100,691585,219690,275346,197159,317478,240280,30001,678538,141008,411407,986591,1032118,433978,976219,887466,714948,377126,539830,224761,475251,84388,255062,35287,329483,1042323,964197,238276,584117,489194,1038696,955944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]