SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381085 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381085 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288205,728216,238679,873773,986268,230947,289781,114339,754963,534085,49450,589990,1033855,303147,385758,215710,140510,310627,65783,695359,619759,534975,884152,739901,527394,859641,1022772,407775,220237,6438,190645,446718,317351,198304,391333,199528,1040139,435430,794344,375589,851068,927305,440617,803300,79223,480996,241481,311430,275469,149032,164798,959923,833402,236934,49472,376571,754507,724693,492771,412791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]