SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393671 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393671 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766213,606061,495873,831281,479166,576637,371043,20446,1004956,426147,462280,149070,643127,27235,180312,468804,675217,596693,716367,812752,755184,162433,642161,1026484,792316,432911,741318,979599,45867,90167,1046169,248040,854694,95110,457471,245249,906238,695951,217312,361781,313190,124265,759191,750554,350641,534236,946462,1032644,919414,1047979,583157,119777,173449,365944,344617,261341,995336,445280,564625,862830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]