SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428072 LIMIT 1 [ RunTime:0.000675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428072 [ RunTime:0.002367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743159,271878,793875,225322,872153,807346,612501,20164,7576,39907,1030427,347516,176794,195647,125608,592910,770897,726506,568573,560244,87525,603097,453641,776688,130191,643563,988949,259592,388183,985526,1020424,519214,992977,709525,52896,833641,375873,1010872,741262,948819,442727,994919,243358,407202,947065,650479,87474,4868,946852,896060,688885,266856,1047513,818124,724583,744374,5594,376731,581250,626826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]