SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343929 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343929 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276052,347628,223525,325311,964363,1041254,784752,91675,708973,3447,281075,236389,885997,361052,455730,1001974,313791,719934,148847,199833,297605,303902,693801,359087,399380,171161,544490,439614,354403,418101,343535,251661,35023,124445,786383,933603,702645,797596,404036,362938,423404,202361,792407,251467,645185,160526,494577,294308,253942,307845,784850,853762,726656,400016,779070,980221,728611,918622,597947,246939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]