SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601118 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601118 [ RunTime:0.003127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785368,589504,918448,836270,547380,831862,797662,314424,124055,262497,171713,53007,900513,660305,47592,533390,929527,993928,250258,926199,691748,845324,743114,1017878,664803,802738,452946,425564,308666,714468,346752,546908,52945,918491,1043083,900986,738063,886427,195133,888570,687118,346729,579494,855382,947783,981334,896169,193727,119165,310383,340188,588349,616574,761641,203321,837366,915980,826751,1004597,866844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001732s ]