SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118897 LIMIT 1 [ RunTime:0.000995s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118897 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244259,36029,628067,419552,116073,367518,462979,206194,772075,708927,941607,1031697,1044043,213556,77343,227088,479278,1039101,1029158,937126,995383,1043279,756460,721087,635839,1023499,478459,300464,15556,167402,924498,115318,180456,50805,447929,989619,405062,283089,1048167,240942,244210,512760,743956,374483,375133,314529,602758,594754,132516,1034101,527149,656598,100049,873872,738575,402487,986271,311605,13788,662784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001073s ]