SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027878 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027878 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347377,1007028,560876,566107,333445,752228,276697,39329,120213,107902,294929,787372,1022740,226422,145495,96920,7642,827646,971705,991999,452760,707404,718341,937932,60532,175786,233673,457081,119502,1018370,741454,860517,759000,946054,548235,108794,868097,481438,636822,934278,237597,1044837,211649,220284,603994,969012,176139,167688,365130,825266,232034,262698,1020764,862431,409222,725452,149165,198479,676669,677632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]